MANVIA BLOG

Eismann / Mysql / Azure Mysql

Azure Mysql

1. login to VM in the azure
2. open mysql workbench app
3. connect to the database
4. select the db and execute the query




                      
CREATE TABLE `logs` (
  `id` int NOT NULL,
  `uuid` varchar(500) DEFAULT NULL,
  `server_ip` varchar(50) DEFAULT NULL,
  `salesman_id` bigint DEFAULT NULL,
  `customerNumber` varchar(100) DEFAULT NULL,
  `identnr1` varchar(200) DEFAULT NULL,
  `changeMark` char(25) DEFAULT NULL,
  `eventCodeHead` char(25) DEFAULT NULL,
  `qraph_function` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `sap_function` text,
  `app_request` text,
  `sap_request` text,
  `sap_error` text,
  `sap_response` text,
  `sap_responseCode` int DEFAULT NULL,
  `server` char(2) DEFAULT NULL,
  `duplicate` char(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `duplicate_sales` char(25) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `bill_amount` decimal(20,2) DEFAULT NULL,
  `payment_method` char(50) DEFAULT NULL,
  `changetype` char(25) DEFAULT NULL,
  `duplicate_identifiers` text,
  `created_at` datetime DEFAULT NULL,
  `request_at` char(50) DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  `response_at` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `logs`
--
ALTER TABLE `logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `qraph_function` (`qraph_function`),
  ADD KEY `salesman_id` (`salesman_id`),
  ADD KEY `customerNumber` (`customerNumber`),
  ADD KEY `identnr1` (`identnr1`),
  ADD KEY `changeMark` (`changeMark`),
  ADD KEY `sap_responseCode` (`sap_responseCode`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `logs`
--
ALTER TABLE `logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;



—--------------------------------------------------------------------------------------------




CREATE TABLE `log_histories` (
  `id` int NOT NULL,
  `log_id` int DEFAULT NULL,
  `uuid` varchar(500) DEFAULT NULL,
  `server_ip` varchar(50) DEFAULT NULL,
  `salesman_id` bigint DEFAULT NULL,
  `customerNumber` varchar(100) DEFAULT NULL,
  `identnr1` varchar(200) DEFAULT NULL,
  `changeMark` char(25) DEFAULT NULL,
  `eventCodeHead` char(25) DEFAULT NULL,
  `qraph_function` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `sap_function` text,
  `app_request` text,
  `sap_request` text,
  `sap_error` text,
  `sap_response` text,
  `sap_responseCode` int DEFAULT NULL,
  `server` char(2) DEFAULT NULL,
  `duplicate` char(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `duplicate_sales` char(25) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `bill_amount` decimal(20,2) DEFAULT NULL,
  `payment_method` char(50) DEFAULT NULL,
  `changetype` char(25) DEFAULT NULL,
  `duplicate_identifiers` text,
  `created_at` datetime DEFAULT NULL,
  `request_at` char(50) DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  `response_at` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `log_histories`
--
ALTER TABLE `log_histories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `qraph_function` (`qraph_function`),
  ADD KEY `salesman_id` (`salesman_id`),
  ADD KEY `customerNumber` (`customerNumber`),
  ADD KEY `identnr1` (`identnr1`),
  ADD KEY `changeMark` (`changeMark`),
  ADD KEY `sap_responseCode` (`sap_responseCode`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `log_histories`
--
ALTER TABLE `log_histories`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;



  —--------------------------------------------------------------------------------------------

  CREATE TABLE users (
  id varchar(255) NOT NULL,
  name varchar(500) DEFAULT NULL,
  device_id varchar(255) DEFAULT NULL,
  last_updated_time datetime DEFAULT NULL,
  updated_at datetime DEFAULT NULL,
  created_at datetime DEFAULT NULL,
  status enum('active','inactive') DEFAULT NULL,
  email varchar(255) DEFAULT NULL,
  password varchar(1000) DEFAULT NULL,
  is_permission int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);




  —--------------------------------------------------------------------------------------------


CREATE TABLE `api_docs` (
  `id` int NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `sap` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `query` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `notes` text,
  `type` char(20) DEFAULT NULL,
  `priority` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




ALTER TABLE `api_docs`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `api_docs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;




  —--------------------------------------------------------------------------------------------

CREATE TABLE `apk_version_histories` (
  `id` int NOT NULL,
  `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `status` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `created_at` datetime DEFAULT NULL,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




ALTER TABLE `apk_version_histories`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `apk_version_histories`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;




—--------------------------------------------------------------------------------------------


CREATE TABLE `apk_versions` (
  `id` int NOT NULL,
  `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `status` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `created_at` datetime DEFAULT NULL,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;




ALTER TABLE `apk_versions`
  ADD PRIMARY KEY (`id`);


ALTER TABLE `apk_versions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;



  —--------------------------------------------------------------------------------------------

  CREATE TABLE session (
  salesman_id varchar(100) NOT NULL,
  device_id varchar(500) DEFAULT NULL,
  token varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  refresh_token varchar(1000) DEFAULT NULL,
  created_at datetime DEFAULT NULL,
  updated_at datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



  —--------------------------------------------------------------------------------------------

CREATE TABLE `apk_versions` (
  `id` int NOT NULL,
  `version` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `status` enum('1','0') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci,
  `created_at` datetime DEFAULT NULL,
  `updated_at` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


ALTER TABLE `apk_versions`
  ADD PRIMARY KEY (`id`);


ALTER TABLE `apk_versions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;